truncate in math

First, the Math object Overview:The purpose of the math (arithmetic) object is to: perform common arithmetic tasks. Save mathematical formulas and information.The Math object provides a much faster execution of the computational functionality than

Recently the project is very busy, the function that gives me is more complex, fortunately can cope with down. In the process of working, I found that the use of MySQL's own function can greatly reduce the complexity of the program. This is

1.SQL IntroductionStructured Query Language(Hierarchical model, mesh model, relational model)The relational model is the current mainstream (Oralce,mysql MSSQL)SQL Standard: ANSI (1992 1997 2002 ISO)Dialect and SQL standardLearner: SQL

There are a number of   mysql functions, here are just a few of the commonly used functions.   Math function abs (x)                             &NBSP ;          //returns the absolute value of x Bin (x)  //returns the binary of X (Oct returns octal,

First, mathematical functionsMathematical functions are mainly used for processing numbers, including integers, floating-point numbers, and so on.ABS (x)Returns the absolute value of XSELECT ABS (-1)--return 1Ceil (x), CEILING (x)Returns the

==============================SQL Memo CRUD queries multi-table events, etc.===============================--------------------------------------------------------------------------------------------------A. Database   1. Creating database   Create

DatabaseI. Database Overview (! Master)1. Database: Warehouse where data is stored (understanding)Hierarchical database, network-based database, relational databaseInstallation and configuration of 2.MYSQL databaseThe installed path does not have

1. Create an employee table (and indicate that the character set is UTF8)Drop table if exists employee;CREATE TABLE Employee (ID int,Name varchar (20),Gender varchar (6),Birthday date,Entry_date date,Job varchar (30),Salary float (5,1),Resume text);2

As shown below: Abs returns the absolute value of the specified number. Acos returns the angle at which the cosine value is the specified number. Asin returns the angle at which the sine value is the specified number. Atan returns the angle of

11:33 2013/6/26 SQL statement: DML (data manipulation Language) statement: Insert Update Delete SelectDDL (data difinition Language-definition Language) statement: Create table/create database/drop database/alter table DCL (the data Control Lan